&1)* 10^(Length(TextToNum("0,."&TelOld&1))-2)); (Middle(@#2 ;3 ;1)-Middle(@#2 ;2 ;1)+2);1) = 0 and Left(@#2;1) < 5 ;"Abo nr begint met een 0"; "OK: " & A
JJLcheckData
If(Left(@#2;1) > 4 ;If(Left (@#2 ;1) = 6 ;"06 Number";"") & If(Left (@#2 ;1) = 8 ;"New Euro free info nr";"") & If(Left (@#2 ;1) = 9 ;"New Euro paid info nr";""); P
If(Left (@#2 ;1)
1 ;"Old nr converted";"") & If(Left (@#2 ;1) = 2 ;"New nr";"")& If(Left (@#2 ;1) = 3 ;"Old and new; same dialling";"Q
")) )))))))))
E: Letter O/o
digit 0! F!'
Too few digits'
Old intern. conv.&
OK: Inter
JJLcheckData
Perf HD
JJLcheckData v3
HFMP3FMP3
FMPR v3.x
ZPerf HD:FileMaker Pro 3.0 Folder:NLphoneCheck2.0:NLphoneCheck2.0:FMPR v3.x:JJLcheckData v3
TextToNum("0,."&Right(TelOld; Length(TelOld)- Position(TelOld;"+";1)))) or (TextToNum("0,."&TelOld) < 1/100) or (Left(@#1;1)=1 and (Length(1&TextToNum(TelOld)) - Length(TextToNum("0,."&Middle(TelOld;Position(Teh/<
JJLcheckData
Nu test op lookup fout2
?? / ? d >>> F!
Now length check2
^("0,."&
&"; "
1)) &1)) - 4
^("0,."&
^("0,."&
&"; "
1)) &1)) - 3
1))&" "&
^("0,."&
^("0,."&
&"; "
1))& 1)) - 2
2))&
&"; "
32) ))))))))
E: O/o
0! F!
9)) > 4
"")&
&"; "
1) -
1) = 6
2) &
&"; "
1) -
1) = 6
9)) > 6
" "
"")&
&"; "
1) -
1) = 6
1))&
1) > 4
^("0,."&
^("0,."&
&"; "
1)) &1)) -
1)-4)&" "
1) > 3
^("0,."&
0,."&
&1))-2))
1) -
1) + 1)& "-0 ?? F!"
"0"&
3))&"-"&
1) > 4
&"; "
1) -
1) = 6
&"; "
1) -
1) = 6
9)) > 2
"")&
&"; "
1) -
1) = 6
2) &
&"; "
1) -
1) = 6
2(1=1
"Now length check") &
^("0,."&
&1)* 10^(
^("0,."&
&"; "
"; "
1))&1))-3)))
1) < 5)
"E: " &
^("0,."&
&1)* 10^(
^("0,."&
&"; "
"; "
1))&1))-3))) -
1))&
^("0,."&
&1)* 10^(
^("0,."&
&"; "
"; "
1))&1))-3))) -
1)) <0
"d <<<< F!"
"d >>>> F!")
^("0,."&
&1)* 10^(
^("0,."&
&1))-2))
(
1)+2)
1) = 0
1) < 5
"E: 0"&
^("0,."&
&1)* 10^(
0,."&
1))))
^("0,."&
) < 1/100)
1)=1
^("0,."&
& "; "
32)&1)))=2)
2(1 = 1
" Nu test op lookup fout") &
= 0
"E: 0"&
) < 4
3))&"-"&
) < 4
10)&"?? / ? d >>> F!"
^("0,."&
&1)* 10^(
^("0,."&
&"; "
"; "
1))&1))-3))) = 8
1) = 1)
"0"&
^("0,."&
)*10^9
3)) & "-" &
^("0,."&
)*10^9
2)) & " " &
^("0,."&
)*10^9
2) & " " &
^("0,."&
)*10^10
&"; "
42572
42575
42577
42578
42579
42576
72222
Now length check
iddle(TelOld;Position(Teer
JJLcheckData
Pro 1.0F!
Pro 3.0
iddle(TelOld;Position(Teer
JJLcheckData
G Comment EH
TelNew#2I
Id@ntL@bel
!!!!! To convert imported or already existing records
you must select
Relookup from the Edit Menu,
with the cursor in the (renamed?) field TelOld. !!!!!!!
TelOld
iddle(TelOld;Position(Teer
JJLcheckData
Single
SingleB
iddle(TelOld;Position(Teer
JJLcheckData
TelOld
030 2222223F
2780300Q
030-222 22 23
A JJL/ShareB
Users
A JJL/ShareB
Users
Helvetica
Monaco
Chicago
New Century Schlbk
Geneva
Courier
Times
Zapf Chancery
entury Schlbk
Geneva
Courier
Times
Zapf Chancery
COMMENT E
ID@NTL@BEL
TELNEW#2
TELOLD
TelOldB
^("0,."&
)*10^6
2)="10"
^("0,."&
)*10^6
2)="13"
^("0,."&
)*10^6
2)="20"
^("0,."&
)*10^6
2)="24"
^("0,."&
)*10^6
2)="26"
^("0,."&
)*10^6
2)="36"
^("0,."&
)*10^6
2)="37"
^("0,."&
)*10^6
2)="40"
^("0,."&
)*10^6
"406")
^("0,."&
)*10^6
2)="50"
^("0,."&
)*10^6
2)="55"
^("0,."&
)*10^6
2)="70"
^("00
Helvetica
Monaco
Chicago
New Century Schlbk
Geneva
Courier
Times
Zapf Chancery
ZRPTH
FPTHAZPerf HD:FileMaker Pro 3.0 Folder:NLphoneCheck2.0:NLphoneCheck2.0:FMPR v3.x:JJLcheckData v3